﻿CREATE TYPE [dbo].[udtProjectAttributes] AS TABLE (
    [ProjectID]   INT             NOT NULL,
    [GaToHm]      BIT             NOT NULL,
    [GaToAl]      BIT             NOT NULL,
    [GaToDi]      BIT             NOT NULL,
    [EiToSi]      BIT             NOT NULL,
    [EiToFl]      BIT             NOT NULL,
    [AnToSeRo]    BIT             NOT NULL,
    [AnToSi]      BIT             NOT NULL,
    [AnToFl]      BIT             NOT NULL,
    [AnToSr]      BIT             NOT NULL,
    [SbGa]        BIT             NOT NULL,
    [SbGh]        BIT             NOT NULL,
    [SbHs]        BIT             NOT NULL,
    [AaEi]        BIT             NOT NULL,
    [AaZa]        BIT             NOT NULL,
    [AaGe]        BIT             NOT NULL,
    [AaEf]        BIT             NOT NULL,
    [Carport]     BIT             NOT NULL,
    [LeDe]        BIT             NOT NULL,
    [LeMo]        BIT             NOT NULL,
    [LeUk]        BIT             NOT NULL,
    [LeBr]        BIT             NOT NULL,
    [LeBrAverage] DECIMAL (11, 2) NOT NULL,
    [LeRe]        BIT             NOT NULL,
    [LeReAverage] DECIMAL (11, 2) NOT NULL,
    [LeBl]        BIT             NOT NULL,
    [LeBlAverage] DECIMAL (11, 2) NOT NULL);




GO
GRANT TAKE OWNERSHIP
    ON TYPE::[dbo].[udtProjectAttributes] TO PUBLIC
    AS [dbo];


GO
GRANT REFERENCES
    ON TYPE::[dbo].[udtProjectAttributes] TO PUBLIC
    AS [dbo];


GO
GRANT CONTROL
    ON TYPE::[dbo].[udtProjectAttributes] TO PUBLIC
    AS [dbo];

